--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: clientes; Type: SCHEMA; Schema: -; Owner: venetel
--

CREATE SCHEMA clientes;


ALTER SCHEMA clientes OWNER TO venetel;

--
-- Name: operaciones; Type: SCHEMA; Schema: -; Owner: venetel
--

CREATE SCHEMA operaciones;


ALTER SCHEMA operaciones OWNER TO venetel;

--
-- Name: seguridad; Type: SCHEMA; Schema: -; Owner: venetel
--

CREATE SCHEMA seguridad;


ALTER SCHEMA seguridad OWNER TO venetel;

--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--

CREATE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;

SET search_path = clientes, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: clientes; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE clientes (
    nm_cliente character(50),
    "RIF_cliente" character(15),
    id integer NOT NULL
);


ALTER TABLE clientes.clientes OWNER TO venetel;

--
-- Name: clientes_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE clientes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.clientes_id_seq OWNER TO venetel;

--
-- Name: clientes_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE clientes_id_seq OWNED BY clientes.id;


--
-- Name: clientes_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('clientes_id_seq', 2, true);


--
-- Name: contratos; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE contratos (
    id integer NOT NULL,
    codigo character(30),
    gerencia_id integer,
    cliente_id integer
);


ALTER TABLE clientes.contratos OWNER TO venetel;

--
-- Name: contratos_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE contratos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.contratos_id_seq OWNER TO venetel;

--
-- Name: contratos_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE contratos_id_seq OWNED BY contratos.id;


--
-- Name: contratos_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('contratos_id_seq', 5, true);


--
-- Name: coordinaciones; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE coordinaciones (
    nm_coordina character(50),
    id integer NOT NULL
);


ALTER TABLE clientes.coordinaciones OWNER TO venetel;

--
-- Name: coordinaciones_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE coordinaciones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.coordinaciones_id_seq OWNER TO venetel;

--
-- Name: coordinaciones_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE coordinaciones_id_seq OWNED BY coordinaciones.id;


--
-- Name: coordinaciones_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('coordinaciones_id_seq', 2, true);


--
-- Name: gerencias; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE gerencias (
    nm_gerencia character(60),
    cliente_id integer,
    id integer NOT NULL
);


ALTER TABLE clientes.gerencias OWNER TO venetel;

--
-- Name: gerencias_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE gerencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.gerencias_id_seq OWNER TO venetel;

--
-- Name: gerencias_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE gerencias_id_seq OWNED BY gerencias.id;


--
-- Name: gerencias_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('gerencias_id_seq', 6, true);


--
-- Name: ppgerencias; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE ppgerencias (
    nm_persona character(60),
    cargo character(60),
    sw_activo boolean,
    gerencia_id integer,
    id integer NOT NULL
);


ALTER TABLE clientes.ppgerencias OWNER TO venetel;

--
-- Name: ppgerencias_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE ppgerencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.ppgerencias_id_seq OWNER TO venetel;

--
-- Name: ppgerencias_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE ppgerencias_id_seq OWNED BY ppgerencias.id;


--
-- Name: ppgerencias_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('ppgerencias_id_seq', 2, true);


SET search_path = operaciones, pg_catalog;

--
-- Name: actas; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE actas (
    id integer NOT NULL,
    coordinacione_id integer,
    proyecto_id integer,
    fl_acta character(12)
);


ALTER TABLE operaciones.actas OWNER TO venetel;

--
-- Name: actas_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE actas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.actas_id_seq OWNER TO venetel;

--
-- Name: actas_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE actas_id_seq OWNED BY actas.id;


--
-- Name: actas_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('actas_id_seq', 1, true);


--
-- Name: entregables; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE entregables (
    id integer NOT NULL,
    servicio_id integer,
    nm_entregable character(90),
    descrip text
);


ALTER TABLE operaciones.entregables OWNER TO venetel;

--
-- Name: entregables_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE entregables_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.entregables_id_seq OWNER TO venetel;

--
-- Name: entregables_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE entregables_id_seq OWNED BY entregables.id;


--
-- Name: entregables_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('entregables_id_seq', 9, true);


--
-- Name: ordenes; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE ordenes (
    id integer NOT NULL,
    nu_orden numeric,
    solpa numeric,
    nu_aceptacion_sap numeric,
    fl_libera character(12),
    proyecto_id integer
);


ALTER TABLE operaciones.ordenes OWNER TO venetel;

--
-- Name: ordenes_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE ordenes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.ordenes_id_seq OWNER TO venetel;

--
-- Name: ordenes_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE ordenes_id_seq OWNED BY ordenes.id;


--
-- Name: ordenes_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('ordenes_id_seq', 2, true);


--
-- Name: precios; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE precios (
    id integer NOT NULL,
    servicio_id integer,
    fl_actualiza character(12),
    precio double precision,
    entregable_id numeric
);


ALTER TABLE operaciones.precios OWNER TO venetel;

--
-- Name: precios_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE precios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.precios_id_seq OWNER TO venetel;

--
-- Name: precios_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE precios_id_seq OWNED BY precios.id;


--
-- Name: precios_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('precios_id_seq', 4, true);


--
-- Name: proyectos; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE proyectos (
    id integer NOT NULL,
    ppgerencia_id integer,
    gerencia_id integer,
    nm_proyecto character(90),
    coordinacion character(90)
);


ALTER TABLE operaciones.proyectos OWNER TO venetel;

--
-- Name: proyectos_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE proyectos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.proyectos_id_seq OWNER TO venetel;

--
-- Name: proyectos_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE proyectos_id_seq OWNED BY proyectos.id;


--
-- Name: proyectos_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('proyectos_id_seq', 2, true);


--
-- Name: servordenes; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE servordenes (
    id integer NOT NULL,
    ordene_id integer,
    servicio_id integer,
    posicion integer,
    cantidad numeric
);


ALTER TABLE operaciones.servordenes OWNER TO venetel;

--
-- Name: serv_ordenes_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE serv_ordenes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.serv_ordenes_id_seq OWNER TO venetel;

--
-- Name: serv_ordenes_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE serv_ordenes_id_seq OWNED BY servordenes.id;


--
-- Name: serv_ordenes_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('serv_ordenes_id_seq', 4, true);


--
-- Name: servicios; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE servicios (
    nm_servicio character(90),
    id integer NOT NULL
);


ALTER TABLE operaciones.servicios OWNER TO venetel;

--
-- Name: servicios_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE servicios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.servicios_id_seq OWNER TO venetel;

--
-- Name: servicios_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE servicios_id_seq OWNED BY servicios.id;


--
-- Name: servicios_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('servicios_id_seq', 8, true);


--
-- Name: servrealizados; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE servrealizados (
    id integer NOT NULL,
    coordinacione_id integer,
    proyecto_id integer,
    ordene_id integer,
    acta_id integer,
    ppgerencia_id integer,
    persona_id integer,
    cantidad numeric,
    descripcion character(150),
    fl_incio character(12),
    fl_fin character(12),
    posicion integer
);


ALTER TABLE operaciones.servrealizados OWNER TO venetel;

--
-- Name: servrealizados_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE servrealizados_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.servrealizados_id_seq OWNER TO venetel;

--
-- Name: servrealizados_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE servrealizados_id_seq OWNED BY servrealizados.id;


--
-- Name: servrealizados_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('servrealizados_id_seq', 2, true);


--
-- Name: textos; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE textos (
    id integer NOT NULL,
    entregable_id integer,
    descripcion character(200)
);


ALTER TABLE operaciones.textos OWNER TO venetel;

--
-- Name: texto_entregables_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE texto_entregables_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.texto_entregables_id_seq OWNER TO venetel;

--
-- Name: texto_entregables_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE texto_entregables_id_seq OWNED BY textos.id;


--
-- Name: texto_entregables_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('texto_entregables_id_seq', 2, true);


--
-- Name: textoactas; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE textoactas (
    id integer DEFAULT nextval('texto_entregables_id_seq'::regclass) NOT NULL,
    acta_id integer,
    descripcion character(200)
);


ALTER TABLE operaciones.textoactas OWNER TO venetel;

SET search_path = public, pg_catalog;

--
-- Name: acos; Type: TABLE; Schema: public; Owner: venetel; Tablespace: 
--

CREATE TABLE acos (
    id integer NOT NULL,
    parent_id integer,
    model character varying(255) DEFAULT NULL::character varying,
    foreign_key integer,
    alias character varying(255) DEFAULT NULL::character varying,
    lft integer,
    rght integer
);


ALTER TABLE public.acos OWNER TO venetel;

--
-- Name: acos_id_seq; Type: SEQUENCE; Schema: public; Owner: venetel
--

CREATE SEQUENCE acos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.acos_id_seq OWNER TO venetel;

--
-- Name: acos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: venetel
--

ALTER SEQUENCE acos_id_seq OWNED BY acos.id;


--
-- Name: acos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: venetel
--

SELECT pg_catalog.setval('acos_id_seq', 72, true);


--
-- Name: aros; Type: TABLE; Schema: public; Owner: venetel; Tablespace: 
--

CREATE TABLE aros (
    id integer NOT NULL,
    parent_id integer,
    model character varying(255) DEFAULT NULL::character varying,
    foreign_key integer,
    alias character varying(255) DEFAULT NULL::character varying,
    lft integer,
    rght integer
);


ALTER TABLE public.aros OWNER TO venetel;

--
-- Name: aros_acos; Type: TABLE; Schema: public; Owner: venetel; Tablespace: 
--

CREATE TABLE aros_acos (
    id integer NOT NULL,
    aro_id integer NOT NULL,
    aco_id integer NOT NULL,
    _create character varying(2) DEFAULT '0'::character varying NOT NULL,
    _read character varying(2) DEFAULT '0'::character varying NOT NULL,
    _update character varying(2) DEFAULT '0'::character varying NOT NULL,
    _delete character varying(2) DEFAULT '0'::character varying NOT NULL
);


ALTER TABLE public.aros_acos OWNER TO venetel;

--
-- Name: aros_acos_id_seq; Type: SEQUENCE; Schema: public; Owner: venetel
--

CREATE SEQUENCE aros_acos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.aros_acos_id_seq OWNER TO venetel;

--
-- Name: aros_acos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: venetel
--

ALTER SEQUENCE aros_acos_id_seq OWNED BY aros_acos.id;


--
-- Name: aros_acos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: venetel
--

SELECT pg_catalog.setval('aros_acos_id_seq', 1, true);


--
-- Name: aros_id_seq; Type: SEQUENCE; Schema: public; Owner: venetel
--

CREATE SEQUENCE aros_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.aros_id_seq OWNER TO venetel;

--
-- Name: aros_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: venetel
--

ALTER SEQUENCE aros_id_seq OWNED BY aros.id;


--
-- Name: aros_id_seq; Type: SEQUENCE SET; Schema: public; Owner: venetel
--

SELECT pg_catalog.setval('aros_id_seq', 3, true);


SET search_path = seguridad, pg_catalog;

--
-- Name: funciones; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE funciones (
    descripcion character(40),
    cod_funcion character(6),
    id integer NOT NULL
);


ALTER TABLE seguridad.funciones OWNER TO venetel;

--
-- Name: funciones_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE funciones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.funciones_id_seq OWNER TO venetel;

--
-- Name: funciones_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE funciones_id_seq OWNED BY funciones.id;


--
-- Name: funciones_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('funciones_id_seq', 1, false);


--
-- Name: funciones_roles; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE funciones_roles (
    id integer NOT NULL,
    funcion_id numeric,
    rol_id numeric
);


ALTER TABLE seguridad.funciones_roles OWNER TO venetel;

--
-- Name: funciones_roles_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE funciones_roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.funciones_roles_id_seq OWNER TO venetel;

--
-- Name: funciones_roles_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE funciones_roles_id_seq OWNED BY funciones_roles.id;


--
-- Name: funciones_roles_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('funciones_roles_id_seq', 1, false);


--
-- Name: personas; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE personas (
    id integer NOT NULL,
    nombres character(30),
    apellidos character(30),
    cedula integer,
    rif character(20),
    telefono numeric,
    correo character(40),
    fl_ingreso character(10),
    fl_egreso character(10),
    fecha_nacimiento character(10),
    razon_social character(30),
    sw_activo boolean DEFAULT true,
    salario numeric,
    telefono_movil character(12),
    cooperativa character(60),
    sw_tipo numeric,
    correo2 character(40),
    correo3 character(40),
    nro_cert integer
);


ALTER TABLE seguridad.personas OWNER TO venetel;

--
-- Name: personas_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE personas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.personas_id_seq OWNER TO venetel;

--
-- Name: personas_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE personas_id_seq OWNED BY personas.id;


--
-- Name: personas_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('personas_id_seq', 14, true);


--
-- Name: roles; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE roles (
    id integer NOT NULL,
    nombre character(30)
);


ALTER TABLE seguridad.roles OWNER TO venetel;

--
-- Name: roles_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.roles_id_seq OWNER TO venetel;

--
-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE roles_id_seq OWNED BY roles.id;


--
-- Name: roles_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('roles_id_seq', 3, true);


--
-- Name: salarios; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE salarios (
    id integer NOT NULL,
    persona_id integer,
    fl_actualiza character(12),
    mt_salario numeric,
    bn_vacaciones numeric,
    utilidades numeric,
    vacaciones numeric,
    bn_celular numeric,
    pr_experiencia numeric,
    bn_alimentacion numeric,
    educacion numeric,
    bn_estaciona numeric
);


ALTER TABLE seguridad.salarios OWNER TO venetel;

--
-- Name: salarios_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE salarios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.salarios_id_seq OWNER TO venetel;

--
-- Name: salarios_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE salarios_id_seq OWNED BY salarios.id;


--
-- Name: salarios_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('salarios_id_seq', 5, true);


--
-- Name: usuarios; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE usuarios (
    id integer NOT NULL,
    usuario character(30),
    clave character(50),
    persona_id integer,
    sw_activo boolean DEFAULT true,
    aro_id integer
);


ALTER TABLE seguridad.usuarios OWNER TO venetel;

--
-- Name: usuarios_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE usuarios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.usuarios_id_seq OWNER TO venetel;

--
-- Name: usuarios_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE usuarios_id_seq OWNED BY usuarios.id;


--
-- Name: usuarios_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('usuarios_id_seq', 15, true);


SET search_path = clientes, pg_catalog;

--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE clientes ALTER COLUMN id SET DEFAULT nextval('clientes_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE contratos ALTER COLUMN id SET DEFAULT nextval('contratos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE coordinaciones ALTER COLUMN id SET DEFAULT nextval('coordinaciones_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE gerencias ALTER COLUMN id SET DEFAULT nextval('gerencias_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE ppgerencias ALTER COLUMN id SET DEFAULT nextval('ppgerencias_id_seq'::regclass);


SET search_path = operaciones, pg_catalog;

--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE actas ALTER COLUMN id SET DEFAULT nextval('actas_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE entregables ALTER COLUMN id SET DEFAULT nextval('entregables_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE ordenes ALTER COLUMN id SET DEFAULT nextval('ordenes_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE precios ALTER COLUMN id SET DEFAULT nextval('precios_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE proyectos ALTER COLUMN id SET DEFAULT nextval('proyectos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE servicios ALTER COLUMN id SET DEFAULT nextval('servicios_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE servordenes ALTER COLUMN id SET DEFAULT nextval('serv_ordenes_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE servrealizados ALTER COLUMN id SET DEFAULT nextval('servrealizados_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE textos ALTER COLUMN id SET DEFAULT nextval('texto_entregables_id_seq'::regclass);


SET search_path = public, pg_catalog;

--
-- Name: id; Type: DEFAULT; Schema: public; Owner: venetel
--

ALTER TABLE acos ALTER COLUMN id SET DEFAULT nextval('acos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: venetel
--

ALTER TABLE aros ALTER COLUMN id SET DEFAULT nextval('aros_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: venetel
--

ALTER TABLE aros_acos ALTER COLUMN id SET DEFAULT nextval('aros_acos_id_seq'::regclass);


SET search_path = seguridad, pg_catalog;

--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE funciones ALTER COLUMN id SET DEFAULT nextval('funciones_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE funciones_roles ALTER COLUMN id SET DEFAULT nextval('funciones_roles_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE personas ALTER COLUMN id SET DEFAULT nextval('personas_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE roles ALTER COLUMN id SET DEFAULT nextval('roles_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE salarios ALTER COLUMN id SET DEFAULT nextval('salarios_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE usuarios ALTER COLUMN id SET DEFAULT nextval('usuarios_id_seq'::regclass);


SET search_path = clientes, pg_catalog;

--
-- Data for Name: clientes; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY clientes (nm_cliente, "RIF_cliente", id) FROM stdin;
CANTV                                             	J-30001203-1   	1
Movilnet                                          	G-20001342-1   	2
\.


--
-- Data for Name: contratos; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY contratos (id, codigo, gerencia_id, cliente_id) FROM stdin;
1	contrato                      	1	1
2	cv-120-aabbbxw                	1	1
3	contrato-1                    	1	1
4	contrato-movilnet             	2	2
5	123445                        	\N	1
\.


--
-- Data for Name: coordinaciones; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY coordinaciones (nm_coordina, id) FROM stdin;
Ingenieria                                        	1
Construccion                                      	2
\.


--
-- Data for Name: gerencias; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY gerencias (nm_gerencia, cliente_id, id) FROM stdin;
Aplicaciones Modulares                                      	1	1
Tecnologia                                                  	2	2
Gcia. Redes de Telecomunicaciones                           	2	3
Gcia. de la Calidad                                         	1	5
Administracion                                              	1	6
\.


--
-- Data for Name: ppgerencias; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY ppgerencias (nm_persona, cargo, sw_activo, gerencia_id, id) FROM stdin;
Jose Perez                                                  	Gerente de tecnologia                                       	t	2	1
Pedro Bonillo                                               	Gerente                                                     	t	6	2
\.


SET search_path = operaciones, pg_catalog;

--
-- Data for Name: actas; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY actas (id, coordinacione_id, proyecto_id, fl_acta) FROM stdin;
1	1	1	12/01/2010  
\.


--
-- Data for Name: entregables; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY entregables (id, servicio_id, nm_entregable, descrip) FROM stdin;
1	3	revision                                                                                  	\N
2	3	determinacion de origen de la falla                                                       	\N
3	3	Reparacion de la Falla                                                                    	\N
4	5	Soporte tecnico de ejecucion de proyectos                                                 	\N
5	8	Ingenieria de Detalle                                                                     	\N
6	8	Revision                                                                                  	\N
7	3	Reparacion de la Falla                                                                    	\N
8	2	Ingenieria de Detalle                                                                     	123\r\n456\r\n789
9	2	123                                                                                       	<ul><li>caracas</li><li>pedro<br></li></ul>
\.


--
-- Data for Name: ordenes; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY ordenes (id, nu_orden, solpa, nu_aceptacion_sap, fl_libera, proyecto_id) FROM stdin;
1	5200163373	373	50000932238	25/11/2011  	1
2	52345678	456899	54321	11/01/2011  	2
\.


--
-- Data for Name: precios; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY precios (id, servicio_id, fl_actualiza, precio, entregable_id) FROM stdin;
4	8	03/01/2011  	1000	1
3	3	01/12/2010  	1000	3
1	2	12/11/2010  	1500	4
\.


--
-- Data for Name: proyectos; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY proyectos (id, ppgerencia_id, gerencia_id, nm_proyecto, coordinacion) FROM stdin;
1	1	2	Interconexion 2011                                                                        	Seguimiento                                                                               
2	2	2	Altas Velocidades                                                                         	Construccion                                                                              
\.


--
-- Data for Name: servicios; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY servicios (nm_servicio, id) FROM stdin;
Informe Periodico de Seguimiento de Actividades Tecnicas alertas y deviaciones            	2
Reparacion de equipos                                                                     	3
Soporte Tecnico de Ejecucion de Proyectos para el seguimiento financiero de los proyectos 	5
Soporte Tecnico de Ejecucion de Proyectos para incios de procesos de puntos de cuenta     	6
Soporte Tecnico de Ejecucion de Proyectos para seguimiento de procesos de puntos de cuenta	7
Ingenieria de Detalle                                                                     	8
\.


--
-- Data for Name: servordenes; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY servordenes (id, ordene_id, servicio_id, posicion, cantidad) FROM stdin;
1	1	5	10	3
2	1	6	20	1
3	1	2	30	4
4	2	3	10	2
\.


--
-- Data for Name: servrealizados; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY servrealizados (id, coordinacione_id, proyecto_id, ordene_id, acta_id, ppgerencia_id, persona_id, cantidad, descripcion, fl_incio, fl_fin, posicion) FROM stdin;
1	1	1	1	0	1	12	2	prueba de esto                                                                                                                                        	12/01/2010  	27/01/2010  	\N
2	1	1	1	0	1	13	2	xxxxx                                                                                                                                                 	12/01/2010  	27/01/2010  	20
\.


--
-- Data for Name: textoactas; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY textoactas (id, acta_id, descripcion) FROM stdin;
\.


--
-- Data for Name: textos; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY textos (id, entregable_id, descripcion) FROM stdin;
1	4	1) Levantamiento de Informacion                                                                                                                                                                         
2	1	prueba de esto                                                                                                                                                                                          
\.


SET search_path = public, pg_catalog;

--
-- Data for Name: acos; Type: TABLE DATA; Schema: public; Owner: venetel
--

COPY acos (id, parent_id, model, foreign_key, alias, lft, rght) FROM stdin;
26	23	\N	\N	add	47	48
61	58	\N	\N	admin_aro	117	118
27	23	\N	\N	edit	49	50
46	39	\N	\N	edit	87	88
4	3	\N	\N	display	3	4
28	23	\N	\N	delete	51	52
5	3	\N	\N	inicializarAuth	5	6
62	58	\N	\N	admin_aco	119	120
3	1	\N	\N	Pages	2	9
6	3	\N	\N	cargarDatos	7	8
47	39	\N	\N	delete	89	90
29	23	\N	\N	inicializarAuth	53	54
23	1	\N	\N	Funciones	42	57
30	23	\N	\N	cargarDatos	55	56
8	7	\N	\N	index	11	12
48	39	\N	\N	inicializarAuth	91	92
9	7	\N	\N	view	13	14
63	58	\N	\N	admin_aro_add	121	122
10	7	\N	\N	add	15	16
39	1	\N	\N	Usuarios	74	95
32	31	\N	\N	admin_index	59	60
11	7	\N	\N	edit	17	18
49	39	\N	\N	cargarDatos	93	94
12	7	\N	\N	delete	19	20
33	31	\N	\N	admin_view	61	62
64	58	\N	\N	admin_aco_define	123	124
13	7	\N	\N	inicializarAuth	21	22
7	1	\N	\N	Personas	10	25
34	31	\N	\N	admin_add	63	64
14	7	\N	\N	cargarDatos	23	24
51	50	\N	\N	index	97	98
35	31	\N	\N	admin_edit	65	66
16	15	\N	\N	admin_index	27	28
65	58	\N	\N	admin_aco_add	125	126
36	31	\N	\N	admin_delete	67	68
17	15	\N	\N	admin_view	29	30
52	50	\N	\N	view	99	100
18	15	\N	\N	admin_add	31	32
37	31	\N	\N	inicializarAuth	69	70
19	15	\N	\N	admin_edit	33	34
31	1	\N	\N	Acos	58	73
66	58	\N	\N	admin_permisos	127	128
38	31	\N	\N	cargarDatos	71	72
20	15	\N	\N	admin_delete	35	36
53	50	\N	\N	add	101	102
21	15	\N	\N	inicializarAuth	37	38
15	1	\N	\N	Aros	26	41
22	15	\N	\N	cargarDatos	39	40
54	50	\N	\N	edit	103	104
40	39	\N	\N	index	75	76
67	58	\N	\N	admin_grupo_permiso	129	130
24	23	\N	\N	index	43	44
41	39	\N	\N	login	77	78
55	50	\N	\N	delete	105	106
25	23	\N	\N	view	45	46
68	58	\N	\N	admin_aro_view_miembros	131	132
56	50	\N	\N	inicializarAuth	107	108
42	39	\N	\N	logout	79	80
50	1	\N	\N	Roles	96	111
43	39	\N	\N	principal	81	82
57	50	\N	\N	cargarDatos	109	110
44	39	\N	\N	view	83	84
69	58	\N	\N	admin_aro_miembro_add	133	134
45	39	\N	\N	add	85	86
70	58	\N	\N	admin_aro_miembro_add_permiso	135	136
59	58	\N	\N	admin_index	113	114
71	58	\N	\N	inicializarAuth	137	138
60	58	\N	\N	admin_aro_view	115	116
1	\N	\N	\N	controllers	1	142
58	1	\N	\N	Acl	112	141
2	\N	\N	\N	actions	143	144
72	58	\N	\N	cargarDatos	139	140
\.


--
-- Data for Name: aros; Type: TABLE DATA; Schema: public; Owner: venetel
--

COPY aros (id, parent_id, model, foreign_key, alias, lft, rght) FROM stdin;
1	\N	\N	\N	Administrador	1	4
2	\N	\N	\N	Visitante	5	6
3	1	Usuario	5	Administrador	2	3
\.


--
-- Data for Name: aros_acos; Type: TABLE DATA; Schema: public; Owner: venetel
--

COPY aros_acos (id, aro_id, aco_id, _create, _read, _update, _delete) FROM stdin;
1	3	1	1	1	1	1
\.


SET search_path = seguridad, pg_catalog;

--
-- Data for Name: funciones; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY funciones (descripcion, cod_funcion, id) FROM stdin;
\.


--
-- Data for Name: funciones_roles; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY funciones_roles (id, funcion_id, rol_id) FROM stdin;
\.


--
-- Data for Name: personas; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY personas (id, nombres, apellidos, cedula, rif, telefono, correo, fl_ingreso, fl_egreso, fecha_nacimiento, razon_social, sw_activo, salario, telefono_movil, cooperativa, sw_tipo, correo2, correo3, nro_cert) FROM stdin;
12	Andres                        	Garcia                        	16877956	V-16877956-4        	2122513555	alvar0@gm.com                           	03/01/2011	03/01/2011	31/01/2011	\N	t	\N	04142905804 	\N	1	\N	\N	\N
13	Milagros                      	Pedroza                       	12671810	V-12671810          	2122513555	al@gm.com                               	11/01/2011	04/01/2011	04/01/2011	\N	t	9000	04142905804 	\N	1	al1@gm.com                              	al2@gm.com                              	\N
14	Jessenia                      	Tejada Pedroza                	16877956	V-16877956-4        	2122513555	javi@venetel.com                        	10/01/2011	25/01/2011	24/01/2011	12                            	t	7500	04142905804 	\N	3	al1@gm.com                              	al2@gm.com                              	3
\.


--
-- Data for Name: roles; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY roles (id, nombre) FROM stdin;
1	Superusuario                  
2	Administrador                 
3	Consulta                      
\.


--
-- Data for Name: salarios; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY salarios (id, persona_id, fl_actualiza, mt_salario, bn_vacaciones, utilidades, vacaciones, bn_celular, pr_experiencia, bn_alimentacion, educacion, bn_estaciona) FROM stdin;
1	14	01/01/2011  	4550	2000	9000	3000	250	230	700	2000	220
\.


--
-- Data for Name: usuarios; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY usuarios (id, usuario, clave, persona_id, sw_activo, aro_id) FROM stdin;
1	cristina                      	1234                                              	\N	t	\N
2	miguel4ngel                   	1234                                              	\N	t	\N
4	jolivieri                     	16599404                                          	3	t	\N
3	miguel4ngel                   	ea398ef10bd14fd24dc2b5cf3e0547df2c3081b7          	2	t	\N
5	admin                         	cecf8a2a1e7be17d29dc0c8df563a03e28a9ea1b          	4	t	\N
6	ftupa                         	00671d5f22548f2d07407520deac63d02c585add          	5	t	\N
7	ftupa                         	a33f7003bd3daf39e03d78ccd3cdb39ec30cbc7b          	6	t	\N
8	prueba                        	a7c8b97f544a0802d633ff3e02bb62d84fd776eb          	7	t	\N
9	azaval                        	dd270d96059a4d3d5bba002b1a8f03319400e174          	8	t	\N
10	\N	\N	9	t	\N
11	\N	\N	10	t	\N
12	\N	\N	11	t	\N
13	\N	\N	12	t	\N
14	\N	\N	13	t	\N
15	                              	39409726a8ca8dc1a4141030b70686a77e702957          	14	t	\N
\.


SET search_path = clientes, pg_catalog;

--
-- Name: clientes_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY clientes
    ADD CONSTRAINT clientes_pkey PRIMARY KEY (id);


--
-- Name: contratos_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY contratos
    ADD CONSTRAINT contratos_pkey PRIMARY KEY (id);


--
-- Name: cordinaciones_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY coordinaciones
    ADD CONSTRAINT cordinaciones_pkey PRIMARY KEY (id);


--
-- Name: gerencias_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY gerencias
    ADD CONSTRAINT gerencias_pkey PRIMARY KEY (id);


--
-- Name: ppgerencias_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY ppgerencias
    ADD CONSTRAINT ppgerencias_pkey PRIMARY KEY (id);


SET search_path = operaciones, pg_catalog;

--
-- Name: actas_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY actas
    ADD CONSTRAINT actas_pkey PRIMARY KEY (id);


--
-- Name: entregables_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY entregables
    ADD CONSTRAINT entregables_pkey PRIMARY KEY (id);


--
-- Name: ordenes_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY ordenes
    ADD CONSTRAINT ordenes_pkey PRIMARY KEY (id);


--
-- Name: precios_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY precios
    ADD CONSTRAINT precios_pkey PRIMARY KEY (id);


--
-- Name: proyectos_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY proyectos
    ADD CONSTRAINT proyectos_pkey PRIMARY KEY (id);


--
-- Name: serv_ordenes_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY servordenes
    ADD CONSTRAINT serv_ordenes_pkey PRIMARY KEY (id);


--
-- Name: servicios_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY servicios
    ADD CONSTRAINT servicios_pkey PRIMARY KEY (id);


--
-- Name: servrealizados_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY servrealizados
    ADD CONSTRAINT servrealizados_pkey PRIMARY KEY (id);


--
-- Name: texto_entregables_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY textos
    ADD CONSTRAINT texto_entregables_pkey PRIMARY KEY (id);


--
-- Name: textoactas_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY textoactas
    ADD CONSTRAINT textoactas_pkey PRIMARY KEY (id);


SET search_path = public, pg_catalog;

--
-- Name: acos_pkey; Type: CONSTRAINT; Schema: public; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY acos
    ADD CONSTRAINT acos_pkey PRIMARY KEY (id);


--
-- Name: aros_acos_pkey; Type: CONSTRAINT; Schema: public; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY aros_acos
    ADD CONSTRAINT aros_acos_pkey PRIMARY KEY (id);


--
-- Name: aros_pkey; Type: CONSTRAINT; Schema: public; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY aros
    ADD CONSTRAINT aros_pkey PRIMARY KEY (id);


SET search_path = seguridad, pg_catalog;

--
-- Name: funciones_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY funciones
    ADD CONSTRAINT funciones_pkey PRIMARY KEY (id);


--
-- Name: funciones_roles_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY funciones_roles
    ADD CONSTRAINT funciones_roles_pkey PRIMARY KEY (id);


--
-- Name: personas_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY personas
    ADD CONSTRAINT personas_pkey PRIMARY KEY (id);


--
-- Name: roles_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);


--
-- Name: salarios_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY salarios
    ADD CONSTRAINT salarios_pkey PRIMARY KEY (id);


--
-- Name: usuarios_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY usuarios
    ADD CONSTRAINT usuarios_pkey PRIMARY KEY (id);


SET search_path = public, pg_catalog;

--
-- Name: aro_aco_key; Type: INDEX; Schema: public; Owner: venetel; Tablespace: 
--

CREATE UNIQUE INDEX aro_aco_key ON aros_acos USING btree (aro_id, aco_id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--

